Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# USER_ROLE_PRIVS

`USER_ROLE_PRIVS` describes the roles granted to the current user.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`USERNAME` | `VARCHAR2(30)` |  | Name of the user, or `PUBLIC`
`GRANTED_ROLE` | `VARCHAR2(30)` |  | Name of the role granted to the user
`ADMIN_OPTION` | `VARCHAR2(3)` |  | Indicates whether the grant was with the `ADMIN OPTION` (`YES`) or not (`NO`)
`DEFAULT_ROLE` | `VARCHAR2(3)` |  | Indicates whether the role is designated as a `DEFAULT ROLE` for the user (`YES`) or not (`NO`)
`OS_GRANTED` | `VARCHAR2(3)` |  | Granted by the operating system (`YES`) or not (`NO`); occurs if configuration parameter `OS_ROLES` = `true`.